package com.itheima.health.dao;


import com.itheima.health.pojo.Order;
import com.itheima.health.pojo.UserOrder;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;


@Mapper
public interface MemberDao {
    /**
     * 查询会员数量
     * @param startDate
     * @param endDate
     * @return
     */
    @Select("SELECT COUNT(id) FROM t_member WHERE reg_time BETWEEN #{startDate} AND #{endDate}")
    int getMemberCountByDate(@Param("startDate") String startDate, @Param("endDate") String endDate);
}
